

/*
Filename: A4_AssignParentNamesVA.do
Goal: Assign parent company names to mutual fund entities based on institutional ownership structures and corporate history.
Contact: mjha@gsu.edu (author) and gormley@wustl.edu

The code is derived from A2_AssignParentNamesHolding
Data Requirements: No external datasets required beyond ISS institutional name data
*/


gen parent_name = ""
gsort institutionid

replace parent_name = "1290 FUNDS" if inlist(institutionid, 6000311)
replace parent_name = "1ST SOURCE CORPORATION INV ADVISORS" if inlist(institutionid, 206000)
replace parent_name = "3D PRINTING FUND ADVISERS" if inlist(institutionid, 6000139)
replace parent_name = "ABBEY CAPITAL LIMITED" if inlist(institutionid, 6000124)
replace parent_name = "ABERDEEN ASSET MANAGEMENT" if inlist(institutionid, 1053)
replace parent_name = "ADIRONDACK RESEARCH & MANAGEMENT" if inlist(institutionid, 206001)
replace parent_name = "ADVANCE CAPITAL MANAGEMENT" if inlist(institutionid, 1060)
replace parent_name = "ADVISORS PREFERRED" if inlist(institutionid, 6000351)
replace parent_name = "AEGIS FINANCIAL CORPORATION" if inlist(institutionid, 1063)
replace parent_name = "AIG" if inlist(institutionid, 6000127)
replace parent_name = "AIG SUNAMERICA" if inlist(institutionid, 1141, 74923)
replace parent_name = "AIM" if inlist(institutionid, 32740)
replace parent_name = "AL FRANK ASSET MANAGEMENT" if inlist(institutionid, 1066)
replace parent_name = "ALLEGIANT" if inlist(institutionid, 53516)
replace parent_name = "ALLIANZ" if inlist(institutionid, 1035, 206221, 6000014, 6000024, 6000052)
replace parent_name = "ALLIED ASSET ADVISORS" if inlist(institutionid, 1067)
replace parent_name = "ALLSTATE INSTITUTIONAL INVESTORS" if inlist(institutionid, 206004)
replace parent_name = "ALPHACENTRIC ADVISORS" if inlist(institutionid, 6000262)
replace parent_name = "ALPHAMARK ADVISORS" if inlist(institutionid, 6000308)
replace parent_name = "ALPINE MANAGEMENT & RESEARCH" if inlist(institutionid, 1068)
replace parent_name = "ALPS" if inlist(institutionid, 206223)
replace parent_name = "AMERICAN ASSOC OF RETIRED PERSONS" if inlist(institutionid, 1052)
replace parent_name = "AMERICAN BEACON ADVISORS" if inlist(institutionid, 1045)
replace parent_name = "AMERICAN CENTURY" if inlist(institutionid, 70245)
replace parent_name = "AMERICAN INDEPENDENCE FINANCIAL SVCS" if inlist(institutionid, 1000)
replace parent_name = "AMERICAN MONEY MANAGEMENT" if inlist(institutionid, 206008)
replace parent_name = "AMERIPRISE" if inlist(institutionid, 10518)
replace parent_name = "AMERISTOCK" if inlist(institutionid, 1128)
replace parent_name = "AMERTICA FIRST CAPITAL MANAGEMENT" if inlist(institutionid, 6000264)
replace parent_name = "AMH EQUITY" if inlist(institutionid, 6000235)
replace parent_name = "AMI ASSET MANAGEMENT CORPORATION" if inlist(institutionid, 6000109)
replace parent_name = "ANCORA ADVISORS" if inlist(institutionid, 206009)
replace parent_name = "APPLETON PARTNERS" if inlist(institutionid, 1074)
replace parent_name = "AQR CAPITAL MANAGEMENT" if inlist(institutionid, 1221)
replace parent_name = "AQUILA" if inlist(institutionid, 1075)
replace parent_name = "ARCHER INVESTMENT CORPORATION" if inlist(institutionid, 6000171)
replace parent_name = "ARIEL" if inlist(institutionid, 1076)
replace parent_name = "ARK INVESTMENT MANAGEMENT" if inlist(institutionid, 6000353)
replace parent_name = "ARNHOLD & S. BLEICHROEDER" if inlist(institutionid, 120382)
replace parent_name = "ARNOLD INVESTMENT COUNSEL" if inlist(institutionid, 206010)
replace parent_name = "ARROW INVESTMENT ADVISORS" if inlist(institutionid, 6000265)
replace parent_name = "ARROWPOINT ASSET MANAGEMENT" if inlist(institutionid, 6000260)
replace parent_name = "ARTISAN PARTNERS" if inlist(institutionid, 47171)
replace parent_name = "ASCENT INVESTMENT ADVISORS" if inlist(institutionid, 6000035)
replace parent_name = "ASHMORE FUNDS" if inlist(institutionid, 6000328)
replace parent_name = "ASPEN PARTNERS" if inlist(institutionid, 6000266)
replace parent_name = "ASPIRATION FUND ADVISER" if inlist(institutionid, 6000329)
replace parent_name = "AST INVESTMENT SERVICES" if inlist(institutionid, 1080)
replace parent_name = "ASTON ASSET MANAGEMENT CO" if inlist(institutionid, 1001)
replace parent_name = "ATLAS ADVISERS" if inlist(institutionid, 1002)
replace parent_name = "AUXIER CAPITAL MANAGEMENT" if inlist(institutionid, 206013)
replace parent_name = "AVENUE CAPITAL MANAGEMENT II" if inlist(institutionid, 6000330)
replace parent_name = "AVONDALE INVESTMENT COMPANY" if inlist(institutionid, 6000255)
replace parent_name = "AXA" if inlist(institutionid, 206003, 5013964, 5013966, 6000119, 8000004)
replace parent_name = "AZZAD ASSET MANAGEMENT" if inlist(institutionid, 206014)
replace parent_name = "BAILLIE GIFFORD OVERSEAS" if inlist(institutionid, 1084)
replace parent_name = "BAMCO" if inlist(institutionid, 1085)
replace parent_name = "BANK OF AMERICA" if inlist(institutionid, 28501, 6000186)
replace parent_name = "BANK OF HAWAII" if inlist(institutionid, 1210)
replace parent_name = "BARCLAYS" if inlist(institutionid, 46137)
replace parent_name = "BARROW HANLEY MEWHINNEY & STRAUSS" if inlist(institutionid, 11169)
replace parent_name = "BB&T" if inlist(institutionid, 1089, 6000145)
replace parent_name = "BERKSHIRE" if inlist(institutionid, 1090)
replace parent_name = "BERTOLET CAPITAL" if inlist(institutionid, 1091)
replace parent_name = "BESSEMER" if inlist(institutionid, 6000107)
replace parent_name = "BISHOP ASSET MANAGEMENT" if inlist(institutionid, 206018)
replace parent_name = "BLACKSTONE" if inlist(institutionid, 6000111, 6000337)
replace parent_name = "BMO" if inlist(institutionid, 6000152)
replace parent_name = "BNYM" if inlist(institutionid, 5100773)
replace parent_name = "BOYAR ASSET MANAGEMENT" if inlist(institutionid, 206026)
replace parent_name = "BOYLE" if inlist(institutionid, 6000155)
replace parent_name = "BPV WEALTH MANAGEMENT" if inlist(institutionid, 6000236)
replace parent_name = "BRAGG FINANCIAL ADVISORS" if inlist(institutionid, 206027)
replace parent_name = "BRANDES INVESTMENT" if inlist(institutionid, 57918)
replace parent_name = "BRAZOS" if inlist(institutionid, 206028)
replace parent_name = "BREMER" if inlist(institutionid, 206029)
replace parent_name = "BRIDGES" if inlist(institutionid, 206030)
replace parent_name = "BRIDGEWAY CAPITAL" if inlist(institutionid, 206031)
replace parent_name = "BROADVIEW ADVISORS" if inlist(institutionid, 6000132)
replace parent_name = "BROWN ADVISORY" if inlist(institutionid, 6000031)
replace parent_name = "BROWN CAPITAL MANAGEMENT" if inlist(institutionid, 6000297)
replace parent_name = "BRUCE" if inlist(institutionid, 206032)
replace parent_name = "BURNHAM ASSET MANAGEMENT" if inlist(institutionid, 206034)
replace parent_name = "C & O FUNDS ADVISOR" if inlist(institutionid, 206035)
replace parent_name = "CALAMOS" if inlist(institutionid, 5557734)
replace parent_name = "CALLAN ASSOCIATES" if inlist(institutionid, 6000354)
replace parent_name = "CALVERT" if inlist(institutionid, 1003)
replace parent_name = "CAMBIAR INVESTORS" if inlist(institutionid, 6000053)
replace parent_name = "CAPITAL GROWTH" if inlist(institutionid, 206037)
replace parent_name = "CAPITAL GUARDIAN" if inlist(institutionid, 64045)
replace parent_name = "CAPITAL IMPACT ADVISOR" if inlist(institutionid, 6000274)
replace parent_name = "CAPITAL MANAGEMENT ASSOCIATES" if inlist(institutionid, 206039)
replace parent_name = "CAPITAL ONE" if inlist(institutionid, 206041)
replace parent_name = "CAPITAL RESEARCH & MANAGEMENT CO" if inlist(institutionid, 64046)
replace parent_name = "CAPSTONE" if inlist(institutionid, 206042)
replace parent_name = "CARL M. LOEB ADVISORY PARTNERS" if inlist(institutionid, 6000114)
replace parent_name = "CARLYLE GMS INVESTMENT MANAGEMENT" if inlist(institutionid, 6000206)
replace parent_name = "CAUSEWAY CAPITAL MANAGEMENT" if inlist(institutionid, 206044)
replace parent_name = "CBRE CLARION SECURITIES" if inlist(institutionid, 6000072)
replace parent_name = "CCM ADVISORS" if inlist(institutionid, 206045)
replace parent_name = "CENTAUR CAPITAL PARTNERS" if inlist(institutionid, 6000187)
replace parent_name = "CENTRE ASSET MANAGEMENT" if inlist(institutionid, 6000189)
replace parent_name = "CENTURY CAPITAL MANAGEMENT" if inlist(institutionid, 206048)
replace parent_name = "CHARLES SCHWAB" if inlist(institutionid, 27875, 74879)
replace parent_name = "CHARTWELL INVESTMENT PARTNERS" if inlist(institutionid, 206049)
replace parent_name = "CHECCHI CAPITAL FUND ADVISERS" if inlist(institutionid, 6000070)
replace parent_name = "CHESWOLD LANE ASSET MANAGEMENT" if inlist(institutionid, 206051)
replace parent_name = "CHICKASAW CAPITAL MANAGEMENT" if inlist(institutionid, 6000038)
replace parent_name = "CITY NATIONAL" if inlist(institutionid, 206174, 6000019, 6000047, 6000331)
replace parent_name = "CLAYMORE" if inlist(institutionid, 1094)
replace parent_name = "CLOUGH CAPITAL PARTNERS" if inlist(institutionid, 206058)
replace parent_name = "COGNIOS CAPITAL" if inlist(institutionid, 6000298)
replace parent_name = "COHEN & STEERS" if inlist(institutionid, 41197)
replace parent_name = "COLUMBIA MANAGEMENT ADVISORS" if inlist(institutionid, 12477)
replace parent_name = "COMMERCE" if inlist(institutionid, 206059)
replace parent_name = "COMMONWEALTH CAPITAL MANAGEMENT" if inlist(institutionid, 1095)
replace parent_name = "COMMUNITY CAPITAL MANAGEMENT" if inlist(institutionid, 206060)
replace parent_name = "COMPASS EFFICIENT MODEL PORTFOLIOS" if inlist(institutionid, 6000355)
replace parent_name = "CONCORDE" if inlist(institutionid, 206061)
replace parent_name = "CONESTOGA CAPITAL ADVISORS" if inlist(institutionid, 206062)
replace parent_name = "CONTEXT CAPITAL ADVISERS" if inlist(institutionid, 6000136)
replace parent_name = "COOK & BYNUM CAPITAL MANAGEMENT" if inlist(institutionid, 6000086)
replace parent_name = "COOKE & BIELER" if inlist(institutionid, 206064)
replace parent_name = "COPELAND CAPITAL MANAGEMENT" if inlist(institutionid, 6000275)
replace parent_name = "COPLEY FINANCIAL" if inlist(institutionid, 206065)
replace parent_name = "CORNERCAP INVESTMENT COUNSEL" if inlist(institutionid, 206066)
replace parent_name = "CORNERSTONE ADVISORS" if inlist(institutionid, 206067)
replace parent_name = "CORNERSTONE CAPITAL MANAGEMENT" if inlist(institutionid, 1155)
replace parent_name = "CORTINA ASSET MANAGEMENT" if inlist(institutionid, 6000276)
replace parent_name = "CRAMER ROSENTHAL MCGLYNN" if inlist(institutionid, 206070)
replace parent_name = "CREDIT SUISSE" if inlist(institutionid, 59154)
replace parent_name = "CROFT-LEOMINSTER" if inlist(institutionid, 206071)
replace parent_name = "CULLEN CAPITAL MANAGEMENT" if inlist(institutionid, 206072)
replace parent_name = "CURIAN CAPITAL" if inlist(institutionid, 6000050)
replace parent_name = "CUSHING MLP ASSET MANAGEMENT LP" if inlist(institutionid, 6000083)
replace parent_name = "CUTLER INVESTMENT COUNSEL" if inlist(institutionid, 206073)
replace parent_name = "CUTWATER" if inlist(institutionid, 6000192)
replace parent_name = "DALTON GRENIER HARTMAN MAHER & CO" if inlist(institutionid, 206074)
replace parent_name = "DAVENPORT & COMPANY" if inlist(institutionid, 1098)
replace parent_name = "DAVID W. TICE" if inlist(institutionid, 206075)
replace parent_name = "DAVIDSON INVESTMENT ADVISORS" if inlist(institutionid, 6000085)
replace parent_name = "DAVIS SELECTED ADVISERS" if inlist(institutionid, 48574)
replace parent_name = "DBX ADVISORS" if inlist(institutionid, 6000333)
replace parent_name = "DENVER INV ADVISORS" if inlist(institutionid, 206076)
replace parent_name = "DESTRA CAPITAL ADVISORS" if inlist(institutionid, 6000034)
replace parent_name = "DEUTSCHE" if inlist(institutionid, 1227, 57478)
replace parent_name = "DFA" if inlist(institutionid, 14920)
replace parent_name = "DIAMOND HILL" if inlist(institutionid, 206079)
replace parent_name = "DIVERSIFIED INVESTMENT ADVISORS" if inlist(institutionid, 206080)
replace parent_name = "DIVIDEND CAPITAL INVESTMENTS" if inlist(institutionid, 206081)
replace parent_name = "DODGE & COX" if inlist(institutionid, 31341)
replace parent_name = "DOMINI SOCIAL INVESTMENTS" if inlist(institutionid, 1100)
replace parent_name = "DOUBLELINE" if inlist(institutionid, 6000059)
replace parent_name = "DREYFUS" if inlist(institutionid, 1129, 15081)
replace parent_name = "DRIEHAUS" if inlist(institutionid, 206084)
replace parent_name = "DUNHAM & ASSOCIATES INVEST COUNSEL" if inlist(institutionid, 6000306)
replace parent_name = "E*TRADE ASSET MANAGEMENT" if inlist(institutionid, 1004)
replace parent_name = "EAGLE ASSET MANAGEMENT" if inlist(institutionid, 6000315)
replace parent_name = "EATON VANCE" if inlist(institutionid, 69951, 206323, 6000176)
replace parent_name = "ELKHORN INVESTMENTS" if inlist(institutionid, 6000182)
replace parent_name = "EMERALD" if inlist(institutionid, 6000163)
replace parent_name = "EMERGING GLOBAL SHARES" if inlist(institutionid, 6000166)
replace parent_name = "EMPOWERED FUNDS" if inlist(institutionid, 6000247)
replace parent_name = "ENTERPRISE CAPITAL M" if inlist(institutionid, 206092)
replace parent_name = "EQUINOX" if inlist(institutionid, 1230)
replace parent_name = "EQUITRUST" if inlist(institutionid, 1101)
replace parent_name = "ETF SECURITIES" if inlist(institutionid, 6000248)
replace parent_name = "ETFIS CAPITAL" if inlist(institutionid, 6000367)
replace parent_name = "EUDORA ASSET MANAGEMENT" if inlist(institutionid, 6000357)
replace parent_name = "EULAV" if inlist(institutionid, 6000334)
replace parent_name = "EVERCORE WEALTH MANAGEMENT" if inlist(institutionid, 6000358)
replace parent_name = "EVERMORE GLOBAL ADVISORS" if inlist(institutionid, 6000060)
replace parent_name = "FACTOR ADVISORS" if inlist(institutionid, 6000084)
replace parent_name = "FAIRHOLME CAPITAL MANAGEMENT" if inlist(institutionid, 206096)
replace parent_name = "FAYEZ SAROFIM & CO" if inlist(institutionid, 75094)
replace parent_name = "FCA CORPORATION" if inlist(institutionid, 206098)
replace parent_name = "FEDERATED" if inlist(institutionid, 1157, 1158, 206228, 206229, 5248385)
replace parent_name = "FENIMORE" if inlist(institutionid, 206099)
replace parent_name = "FIDELITY" if inlist(institutionid, 16925)
replace parent_name = "FIDUCIARY ASSET MANAGEMENT" if inlist(institutionid, 1102)
replace parent_name = "FIFTH THIRD" if inlist(institutionid, 206101)
replace parent_name = "FIRST ASSOCIATED INVESTOR ADVISORS" if inlist(institutionid, 6000009)
replace parent_name = "FIRST AUSTIN CAPITAL MANAGEMENT" if inlist(institutionid, 206103, 6000058)
replace parent_name = "FIRST EAGLE" if inlist(institutionid, 6000104)
replace parent_name = "FIRST INVESTORS" if inlist(institutionid, 1036)
replace parent_name = "FIRST NATL BANK OF OMAHA" if inlist(institutionid, 6000290)
replace parent_name = "FIRST PACIFIC ADVISORS" if inlist(institutionid, 206105)
replace parent_name = "FIRST TENNESSEE BANK" if inlist(institutionid, 206106)
replace parent_name = "FIRST TRUST" if inlist(institutionid, 206108)
replace parent_name = "FOCUSSHARES" if inlist(institutionid, 6000037)
replace parent_name = "FORESTER CAPITAL MANAGEMENT" if inlist(institutionid, 206280)
replace parent_name = "FORETHOUGHT INVESTMENT ADVISORS" if inlist(institutionid, 6000245)
replace parent_name = "FORT PITT CAPITAL GROUP" if inlist(institutionid, 1159)
replace parent_name = "FORWARD" if inlist(institutionid, 6000196)
replace parent_name = "FRANK CAPITAL PARTNERS" if inlist(institutionid, 206118)
replace parent_name = "FRANKLIN TEMPLETON" if inlist(institutionid, 1198, 48884, 64400, 206232, 5014128)
replace parent_name = "FRED ALGER" if inlist(institutionid, 1104)
replace parent_name = "FRIEDMAN BILLINGS RAMSEY & CO" if inlist(institutionid, 206097)
replace parent_name = "FRIESS ASSOCIATES" if inlist(institutionid, 206121)
replace parent_name = "FRONT STREET CAPITAL MANAGEMENT" if inlist(institutionid, 6000278)
replace parent_name = "FRONTEGRA" if inlist(institutionid, 206122)
replace parent_name = "FUNDX INVESTMENT GROUP" if inlist(institutionid, 6000249)
replace parent_name = "GABELLI" if inlist(institutionid, 1105, 17161)
replace parent_name = "GARDNER LEWIS ASSET MANAGEMENT" if inlist(institutionid, 6000002)
replace parent_name = "GATEWAY INVESTMENT ADVISERS" if inlist(institutionid, 1211)
replace parent_name = "GATOR CAPITAL MANAGEMENT" if inlist(institutionid, 6000197)
replace parent_name = "GE ASSET MANAGEMENT" if inlist(institutionid, 17252)
replace parent_name = "GENWORTH FINANCIAL WEALTH MANAGEMENT" if inlist(institutionid, 206012, 6000045)
replace parent_name = "GLENMEDE" if inlist(institutionid, 6000051)
replace parent_name = "GLOBAL X MANAGEMENT COMPANY" if inlist(institutionid, 6000027)
replace parent_name = "GOLDMAN SACHS" if inlist(institutionid, 75938)
replace parent_name = "GOODHAVEN CAPITAL MANAGEMENT" if inlist(institutionid, 6000378)
replace parent_name = "GRANTHAM MAYO VAN OTTERLOO & CO" if inlist(institutionid, 17417)
replace parent_name = "GRANUM CAPITAL MANAGEMENT" if inlist(institutionid, 1162)
replace parent_name = "GREEN CENTURY CAPITAL MANAGEMENT" if inlist(institutionid, 6000310)
replace parent_name = "GUARDIAN INVESTOR SERVICES" if inlist(institutionid, 1044, 206234)
replace parent_name = "GUGGENHEIM" if inlist(institutionid, 6000033)
replace parent_name = "GUIDESTONE FUNDS TRUST" if inlist(institutionid, 1006)
replace parent_name = "HANSBERGER GLOBAL INVESTORS" if inlist(institutionid, 206124)
replace parent_name = "HARBOR CAPITAL" if inlist(institutionid, 1007)
replace parent_name = "HARDING LOEVNER MANAGEMENT" if inlist(institutionid, 206125)
replace parent_name = "HARRIS ASSOCIATES" if inlist(institutionid, 17770)
replace parent_name = "HARTFORD" if inlist(institutionid, 206126)
replace parent_name = "HATTERAS" if inlist(institutionid, 1069, 6000087)
replace parent_name = "HEARTLAND" if inlist(institutionid, 1163)
replace parent_name = "HENDERSON INVESTMENT MANAGEMENT" if inlist(institutionid, 1164)
replace parent_name = "HENNESSY" if inlist(institutionid, 206235)
replace parent_name = "HENSSLER" if inlist(institutionid, 206288)
replace parent_name = "HGK ASSET MANAGEMENT" if inlist(institutionid, 6000030)
replace parent_name = "HIGHLAND" if inlist(institutionid, 206128)
replace parent_name = "HIGHMARK CAPITAL MANAGEMENT" if inlist(institutionid, 1215)
replace parent_name = "HILLMAN CAPITAL MANAGEMENT" if inlist(institutionid, 6000317)
replace parent_name = "HOLLAND" if inlist(institutionid, 1212)
replace parent_name = "HOLLAND AND COMPANY" if inlist(institutionid, 6000177)
replace parent_name = "HOTCHKIS & WILEY" if inlist(institutionid, 74314)
replace parent_name = "HSBC INVESTMENTS (USA)" if inlist(institutionid, 1008)
replace parent_name = "HUNTINGTON" if inlist(institutionid, 1165)
replace parent_name = "HUSSMAN STRATEGIC ADVISORS" if inlist(institutionid, 6000279)
replace parent_name = "ICON FUNDS" if inlist(institutionid, 206236)
replace parent_name = "INDEPENDENCE CAPITAL MANAGEMENT" if inlist(institutionid, 206237)
replace parent_name = "INDEX INVESTMENTS" if inlist(institutionid, 1108)
replace parent_name = "ING/VOYA" if inlist(institutionid, 1009, 206238, 206292, 8000015)
replace parent_name = "INNOVATOR MANAGEMENT" if inlist(institutionid, 6000173)
replace parent_name = "INTEGRITY MANAGEMENT" if inlist(institutionid, 206131)
replace parent_name = "INTEGRITY MONEY MANAGEMENT" if inlist(institutionid, 1146)
replace parent_name = "INTERNATIONAL STRATEGY & INVESTMENT" if inlist(institutionid, 206239)
replace parent_name = "INTERNATIONAL VALUE ADVISORS" if inlist(institutionid, 6000202)
replace parent_name = "INTREPID CAPITAL MANAGEMENT" if inlist(institutionid, 1166)
replace parent_name = "INVESCO" if inlist(institutionid, 74556, 206155, 6000036)
replace parent_name = "INVESTMENT HOUSE" if inlist(institutionid, 6000227)
replace parent_name = "INVESTMENT RESEARCH CORPORATION" if inlist(institutionid, 6000079)
replace parent_name = "IRONBRIDGE CAPITAL MANAGEMENT" if inlist(institutionid, 6000041)
replace parent_name = "JACOBS ASSET MANAGEMENT" if inlist(institutionid, 6000055)
replace parent_name = "JANUS" if inlist(institutionid, 19481)
replace parent_name = "JENSEN INVESTMENT MANAGEMENT" if inlist(institutionid, 1168)
replace parent_name = "JOHN HANCOCK" if inlist(institutionid, 1010)
replace parent_name = "JOHNSON INVESTMENT COUNSEL" if inlist(institutionid, 6000338)
replace parent_name = "JP MORGAN CHASE" if inlist(institutionid, 21352)
replace parent_name = "JULIUS BAER INVESTMENT MANAGEMENT" if inlist(institutionid, 79858)
replace parent_name = "KALMAR" if inlist(institutionid, 1169)
replace parent_name = "KEELEY" if inlist(institutionid, 1171)
replace parent_name = "KELMOORE INVESTMENT COMPANY" if inlist(institutionid, 1172)
replace parent_name = "KENSINGTON INVESTMENT MANAGEMENT" if inlist(institutionid, 1173)
replace parent_name = "KEYCORP" if inlist(institutionid, 76516)
replace parent_name = "KILLEN GROUP" if inlist(institutionid, 1130)
replace parent_name = "KINETICS ASSET MANAGEMENT" if inlist(institutionid, 1174)
replace parent_name = "KIRR MARBACH & COMPANY" if inlist(institutionid, 1175)
replace parent_name = "KKR ASSET MANAGEMENT" if inlist(institutionid, 6000075)
replace parent_name = "KOPP INVESTMENT ADVISORS" if inlist(institutionid, 1176)
replace parent_name = "KORNITZER CAPITAL MANAGEMENT" if inlist(institutionid, 1110)
replace parent_name = "KRANE FUNDS ADVISORS" if inlist(institutionid, 6000116)
replace parent_name = "L. ROY PAPP & ASSOCIATES" if inlist(institutionid, 6000204)
replace parent_name = "LADENBURG THALMANN ASSET MANAGEMENT" if inlist(institutionid, 6000170)
replace parent_name = "LATTICE STRATEGIES" if inlist(institutionid, 6000250)
replace parent_name = "LAWSON KROEKER INVESTMENT MANAGEMENT" if inlist(institutionid, 6000080)
replace parent_name = "LAZARD FRERES & COMPANY" if inlist(institutionid, 48098)
replace parent_name = "LEADER CAPITAL CORPORATION" if inlist(institutionid, 1111)
replace parent_name = "LEE FINANCIAL GROUP" if inlist(institutionid, 206136)
replace parent_name = "LEGG MASON" if inlist(institutionid, 1088, 1134, 50700, 206240, 5027808)
replace parent_name = "LEHMAN BROTHERS" if inlist(institutionid, 1042)
replace parent_name = "LEUTHOLD WEEDEN CAPITAL MANAGMENT" if inlist(institutionid, 6000042)
replace parent_name = "LINCOLN INVESTMENT" if inlist(institutionid, 206227)
replace parent_name = "LITMAN/GREGORY FUND ADVISORS" if inlist(institutionid, 6000044)
replace parent_name = "LOCORR FUND MANAGEMENT" if inlist(institutionid, 6000280)
replace parent_name = "LOOMIS SAYLES & COMPANY" if inlist(institutionid, 20445)
replace parent_name = "LORD ABBETT & COMPANY" if inlist(institutionid, 20448)
replace parent_name = "LOTSOFF" if inlist(institutionid, 206218)
replace parent_name = "LUTHER KING CAPITAL MANAGEMENT CORPORATION" if inlist(institutionid, 1177)
replace parent_name = "MADISON" if inlist(institutionid, 206298)
replace parent_name = "MAIRS AND POWERS" if inlist(institutionid, 1179)
replace parent_name = "MANAGERS INVESTMENT GROUP" if inlist(institutionid, 1030)
replace parent_name = "MANNING & NAPIER ADVISORS" if inlist(institutionid, 6000062)
replace parent_name = "MARKETOCRACY" if inlist(institutionid, 206299)
replace parent_name = "MARSHALL & ILSLEY CORP" if inlist(institutionid, 1178, 206259)
replace parent_name = "MARSICO CAPITAL MANAGEMENT" if inlist(institutionid, 84101)
replace parent_name = "MASON STREET" if inlist(institutionid, 206241)
replace parent_name = "MASSACHUSETTS FINANCIAL SERVS. CO" if inlist(institutionid, 1180)
replace parent_name = "MASSMUTUAL" if inlist(institutionid, 1011, 23935)
replace parent_name = "MATRIX ASSET ADVISORS" if inlist(institutionid, 6000043)
replace parent_name = "MATTHEW 25 MANAGEMENT CORPORATION" if inlist(institutionid, 6000007)
replace parent_name = "MATTHEWS INTL CAPITAL MANAGEMENT" if inlist(institutionid, 1181)
replace parent_name = "MCCARTHY GROUP ASSET MANAGEMENT" if inlist(institutionid, 206139)
replace parent_name = "MCCORMICK CAPITAL MANAGEMENT" if inlist(institutionid, 206140)
replace parent_name = "MCKINLEY CAPITAL MANAGEMENT" if inlist(institutionid, 1223)
replace parent_name = "MELLON INSTITUTIONAL FUNDS" if inlist(institutionid, 5014056)
replace parent_name = "MERCANTILE" if inlist(institutionid, 1012)
replace parent_name = "MERCER INVESTMENT MANAGEMENT" if inlist(institutionid, 1013)
replace parent_name = "MERITAGE CAPITAL" if inlist(institutionid, 6000117)
replace parent_name = "MERRILL LYNCH" if inlist(institutionid, 89688)
replace parent_name = "METLIFE" if inlist(institutionid, 1031)
replace parent_name = "MH INVESTMENT MANAGEMENT" if inlist(institutionid, 6000018)
replace parent_name = "MIDAS MANAGEMENT CORPORATION" if inlist(institutionid, 1183)
replace parent_name = "MILLER/HOWARD INVESTMENTS" if inlist(institutionid, 6000208)
replace parent_name = "MILLINGTON SECURITIES" if inlist(institutionid, 6000340)
replace parent_name = "MIRAE ASSET GLOBAL INVESTMENTS (USA)" if inlist(institutionid, 6000246, 6000304)
replace parent_name = "MMA CAPITAL MANAGEMENT" if inlist(institutionid, 206243)
replace parent_name = "MONDRIAN INVESTMENT PARTNERS" if inlist(institutionid, 1224)
replace parent_name = "MONETTA FINANCIAL SVCS" if inlist(institutionid, 206301)
replace parent_name = "MORGAN ASSET MANAGEMENT" if inlist(institutionid, 206143)
replace parent_name = "MORGAN CREEK" if inlist(institutionid, 6000282)
replace parent_name = "MORGAN DEMPSEY CAPITAL MANAGEMENT" if inlist(institutionid, 6000049)
replace parent_name = "MORGAN STANLEY" if inlist(institutionid, 1113, 206245)
replace parent_name = "MOTLEY FOOL ASSET MANAGEMENT" if inlist(institutionid, 6000210)
replace parent_name = "MUHLENKAMP & COMPANY" if inlist(institutionid, 206145)
replace parent_name = "MUNDER CAPITAL" if inlist(institutionid, 1148)
replace parent_name = "MUTUAL OF AMERICA CAP MANAGEMENT CORPORATION" if inlist(institutionid, 206246)
replace parent_name = "NASHVILLE CAPITAL CORPORATION" if inlist(institutionid, 6000283)
replace parent_name = "NATIONAL FUND ADVISORS" if inlist(institutionid, 6000110)
replace parent_name = "NATIONWIDE" if inlist(institutionid, 1005, 1185)
replace parent_name = "NAVELLIER MANAGEMENT" if inlist(institutionid, 1186)
replace parent_name = "NAVIGATOR MONEY MANAGEMENT" if inlist(institutionid, 6000020)
replace parent_name = "NEEDHAM INVESTMENT MANAGEMENT" if inlist(institutionid, 1189)
replace parent_name = "NEIMAN" if inlist(institutionid, 206303)
replace parent_name = "NEUBERGER BERMAN" if inlist(institutionid, 5102137)
replace parent_name = "NEW YORK LIFE" if inlist(institutionid, 1015, 206242)
replace parent_name = "NICHOLAS COMPANY" if inlist(institutionid, 1114)
replace parent_name = "NILE CAPITAL MANAGEMENT" if inlist(institutionid, 6000143)
replace parent_name = "NOMURA" if inlist(institutionid, 6000154)
replace parent_name = "NORTH COUNTRY INVESTMENT ADVISERS" if inlist(institutionid, 6000213)
replace parent_name = "NORTHEAST MANAGEMENT & RESEARCH" if inlist(institutionid, 206212)
replace parent_name = "NORTHERN TRUST" if inlist(institutionid, 206248, 5102167)
replace parent_name = "NORTHWESTERN MUTUAL INV SVCS" if inlist(institutionid, 1016)
replace parent_name = "NUANCE INVESTMENTS" if inlist(institutionid, 6000054)
replace parent_name = "NUVEEN" if inlist(institutionid, 1116)
replace parent_name = "NVEST FUND MANAGEMENT" if inlist(institutionid, 1041, 1149)
replace parent_name = "OAK ASSOCIATES" if inlist(institutionid, 1218)
replace parent_name = "OAK VALUE CAPITAL MANAGEMENT" if inlist(institutionid, 206216)
replace parent_name = "OAKTREE CAPITAL MANAGEMENT" if inlist(institutionid, 6000258)
replace parent_name = "OBERWEIS ASSET MANAGEMENT" if inlist(institutionid, 6000013)
replace parent_name = "OHIO NATIONAL" if inlist(institutionid, 1017)
replace parent_name = "OLD MUTUAL CAPITAL" if inlist(institutionid, 1032)
replace parent_name = "OLIVE STREET INVESTMENT ADVISERS" if inlist(institutionid, 6000284)
replace parent_name = "OLSTEIN CAPITAL MANAGEMENT" if inlist(institutionid, 1191)
replace parent_name = "ONE COMPASS ADVISORS" if inlist(institutionid, 1038)
replace parent_name = "OPCAP ADVISORS" if inlist(institutionid, 206149)
replace parent_name = "OPTIQUE CAPITAL MANAGEMENT" if inlist(institutionid, 206334)
replace parent_name = "ORBITEX-SARATOGA" if inlist(institutionid, 6000321)
replace parent_name = "PACIFIC GLOBAL" if inlist(institutionid, 6000341)
replace parent_name = "PACIFIC LIFE" if inlist(institutionid, 6000001)
replace parent_name = "PARNASSUS INVESTMENTS" if inlist(institutionid, 1150)
replace parent_name = "PAX WORLD MANAGEMENT" if inlist(institutionid, 1151)
replace parent_name = "PAYDEN & RYGEL" if inlist(institutionid, 206331)
replace parent_name = "PENN CAPITAL MANAGEMENT COMPANY" if inlist(institutionid, 6000379)
replace parent_name = "PENNANT MANAGEMENT" if inlist(institutionid, 6000077)
replace parent_name = "PERRITT" if inlist(institutionid, 6000342)
replace parent_name = "PHILADELPHIA INVESTMENT PARTNERS" if inlist(institutionid, 1225)
replace parent_name = "PHOCAS FINANCIAL CORPORATION" if inlist(institutionid, 6000141)
replace parent_name = "PHOENIX" if inlist(institutionid, 1020, 1117)
replace parent_name = "PINNACLE" if inlist(institutionid, 6000217)
replace parent_name = "PINNACLE CAPITAL MANAGEMENT" if inlist(institutionid, 6000219)
replace parent_name = "PIONEER" if inlist(institutionid, 24485, 206250)
replace parent_name = "PNC" if inlist(institutionid, 74503, 6000125)
replace parent_name = "POTKUL CAPITAL MANAGEMENT" if inlist(institutionid, 206154)
replace parent_name = "PRECIDIAN FUNDS" if inlist(institutionid, 6000285)
replace parent_name = "PRIMECAP MANAGEMENT COMPANY" if inlist(institutionid, 49666)
replace parent_name = "PRINCIPAL MANAGEMENT" if inlist(institutionid, 6000113)
replace parent_name = "PROFIT INVESTMENT MANAGEMENT" if inlist(institutionid, 206157)
replace parent_name = "PROFUNDS" if inlist(institutionid, 1118, 206158)
replace parent_name = "PROGRESSIVE INVESTMENT MANAGEMENT CORPORATION" if inlist(institutionid, 1119)
replace parent_name = "PROSPECTOR PARTNERS ASSET MANAGEMENT" if inlist(institutionid, 206329)
replace parent_name = "PROVIDENT INVESTMENT COUNSEL" if inlist(institutionid, 1228)
replace parent_name = "PRUDENTIAL" if inlist(institutionid, 1021, 1167, 206251)
replace parent_name = "PSG INVESTMENT ADVISORS" if inlist(institutionid, 6000167)
replace parent_name = "PUTNAM" if inlist(institutionid, 76204, 206095)
replace parent_name = "QUAKER MANAGEMENT CORP" if inlist(institutionid, 206159)
replace parent_name = "QUANTITATIVE INVESTMENT ADVISORS" if inlist(institutionid, 205487)
replace parent_name = "R. MEEDER & ASSOCIATES" if inlist(institutionid, 6000011)
replace parent_name = "RAFFERTY" if inlist(institutionid, 206160)
replace parent_name = "RAINIER INVESTMENT MANAGEMENT" if inlist(institutionid, 206161)
replace parent_name = "RAMIUS" if inlist(institutionid, 6000345)
replace parent_name = "RCM CAPITAL MANAGEMENT" if inlist(institutionid, 1193, 206252)
replace parent_name = "RECON CAPITAL ADVISORS" if inlist(institutionid, 6000362)
replace parent_name = "REGAL INVESTMENT ADVISORS" if inlist(institutionid, 6000133)
replace parent_name = "REICH & TANG" if inlist(institutionid, 206164)
replace parent_name = "RENAISSANCE CAPITAL CORPORATION" if inlist(institutionid, 206166)
replace parent_name = "REYNOLDS CAPITAL MANAGEMENT" if inlist(institutionid, 206170)
replace parent_name = "RIDGEWORTH" if inlist(institutionid, 1217, 6000017)
replace parent_name = "RIVERNORTH CAPITAL MANAGEMENT" if inlist(institutionid, 206171)
replace parent_name = "RIVERPARK ADVISORS" if inlist(institutionid, 6000046)
replace parent_name = "RMR ADVISORS" if inlist(institutionid, 206172)
replace parent_name = "ROBERT W BAIRD & COMPANY" if inlist(institutionid, 1120)
replace parent_name = "RODNEY SQUARE MANAGEMENT CORP" if inlist(institutionid, 206175)
replace parent_name = "ROXBURY CAPITAL MANAGEMENT" if inlist(institutionid, 206211)
replace parent_name = "RS INVESTMENT MANAGEMENT CO" if inlist(institutionid, 1022)
replace parent_name = "RUANE CUNIFF & GOLDFARB" if inlist(institutionid, 6000241)
replace parent_name = "RUSSELL INVESTMENT GROUP" if inlist(institutionid, 74243)
replace parent_name = "RYDEX" if inlist(institutionid, 206253)
replace parent_name = "SALIENT" if inlist(institutionid, 6000056)
replace parent_name = "SANDS CAPITAL MANAGEMENT" if inlist(institutionid, 1220)
replace parent_name = "SATURNA CAPITAL CORPORATION" if inlist(institutionid, 1121)
replace parent_name = "SCHRODER" if inlist(institutionid, 1194)
replace parent_name = "SCHWARTZ INVESTMENT COUNSEL" if inlist(institutionid, 6000220)
replace parent_name = "SEAFARER CAPITAL PARTNERS" if inlist(institutionid, 6000100)
replace parent_name = "SEI" if inlist(institutionid, 206315)
replace parent_name = "SELIGMAN" if inlist(institutionid, 1024, 1213)
replace parent_name = "SENTINEL" if inlist(institutionid, 206056, 206327)
replace parent_name = "SGI" if inlist(institutionid, 1043, 6000016)
replace parent_name = "SHAY ASSETS" if inlist(institutionid, 1123)
replace parent_name = "SHEETS SMITH WEALTH MANAGEMENT" if inlist(institutionid, 206178)
replace parent_name = "SHELTON CAPITAL MANAGEMENT" if inlist(institutionid, 6000078)
replace parent_name = "SIT" if inlist(institutionid, 1124)
replace parent_name = "SKYHAWK CAPITAL MANAGEMENT" if inlist(institutionid, 1195)
replace parent_name = "SMEAD CAPITAL MANAGEMENT" if inlist(institutionid, 6000159)
replace parent_name = "SOCIETE GENERALE" if inlist(institutionid, 27450)
replace parent_name = "SOUND SHORE MANAGEMENT" if inlist(institutionid, 206319)
replace parent_name = "SOUTHEASTERN ASSET MANAGEMENT" if inlist(institutionid, 26620)
replace parent_name = "SPARROW CAPITAL MANAGEMENT" if inlist(institutionid, 6000144)
replace parent_name = "SPARX INVESTMENT & RESEARCH USA" if inlist(institutionid, 206214)
replace parent_name = "SPIRIT OF AMERICA MANAGEMENT CORPORATION" if inlist(institutionid, 206320)
replace parent_name = "ST DENIS J VILLERE & COMPANY" if inlist(institutionid, 6000108)
replace parent_name = "STAAR" if inlist(institutionid, 1216)
replace parent_name = "STATE FARM" if inlist(institutionid, 26812, 6000322)
replace parent_name = "STATE STREET" if inlist(institutionid, 206321, 5102330)
replace parent_name = "STEIN ROE" if inlist(institutionid, 1126)
replace parent_name = "STEWART CAPITAL ADVISORS" if inlist(institutionid, 6000224)
replace parent_name = "STONE HARBOR INVESTMENT PARTNERS" if inlist(institutionid, 6000348)
replace parent_name = "STONE RIDGE ASSET MANAGEMENT" if inlist(institutionid, 6000082)
replace parent_name = "STONEBRIDGE CAPITAL ADVISORS" if inlist(institutionid, 6000010)
replace parent_name = "STRALEM & COMPANY" if inlist(institutionid, 1196)
replace parent_name = "STRATEGIC PARTNERS MUTUAL FUNDS" if inlist(institutionid, 1025)
replace parent_name = "STRATTON MANAGEMENT" if inlist(institutionid, 6000239)
replace parent_name = "SUMMIT INVESTMENT PARTNERS" if inlist(institutionid, 1197)
replace parent_name = "SYMETRA INVESTMENT MANAGEMENT" if inlist(institutionid, 6000089)
replace parent_name = "T ROWE PRICE" if inlist(institutionid, 24673)
replace parent_name = "TD" if inlist(institutionid, 6000226)
replace parent_name = "TFS CAPITAL" if inlist(institutionid, 206215)
replace parent_name = "THE MONEYPAPER ADVISOR" if inlist(institutionid, 6000228)
replace parent_name = "THIRD AVENUE" if inlist(institutionid, 1199)
replace parent_name = "THOMAS WHITE INTERNATIONAL" if inlist(institutionid, 6000271)
replace parent_name = "THORNBURG" if inlist(institutionid, 29928)
replace parent_name = "THRIVENT" if inlist(institutionid, 73871)
replace parent_name = "TIAA-CREF" if inlist(institutionid, 74659)
replace parent_name = "TIMESSQUARE" if inlist(institutionid, 1229)
replace parent_name = "TOCQUEVILLE ASSET MANAGEMENT" if inlist(institutionid, 1200)
replace parent_name = "TOEWS CORPORATION" if inlist(institutionid, 6000164)
replace parent_name = "TOREADOR RESEARCH & TRADING" if inlist(institutionid, 6000301)
replace parent_name = "TORRAY CORPORATION" if inlist(institutionid, 1201)
replace parent_name = "TORTOISE CAPITAL ADVISORS" if inlist(institutionid, 6000151, 6000325)
replace parent_name = "TOUCHSTONE ADVISORS" if inlist(institutionid, 1034)
replace parent_name = "TRANSAMERICA" if inlist(institutionid, 1026)
replace parent_name = "TRENDSTAR ADVISORS" if inlist(institutionid, 1202)
replace parent_name = "TRILLIUM" if inlist(institutionid, 8000023)
replace parent_name = "TRIM TABS ASSET MANAGEMENT" if inlist(institutionid, 6000229)
replace parent_name = "TRINITY FIDUCIARY PARTNERS" if inlist(institutionid, 206180)
replace parent_name = "TRUSTMARK NATIONAL BANK" if inlist(institutionid, 1204)
replace parent_name = "TURNER INVESTMENTS" if inlist(institutionid, 206181)
replace parent_name = "TYGH CAPITAL MANAGEMENT" if inlist(institutionid, 6000040)
replace parent_name = "UBS" if inlist(institutionid, 11585)
replace parent_name = "UMB" if inlist(institutionid, 206177)
replace parent_name = "US BANCORP" if inlist(institutionid, 103059, 6000105)
replace parent_name = "US GLOBAL INVESTORS" if inlist(institutionid, 206183)
replace parent_name = "USAA INVESTMENT MANAGEMENT COMPANY" if inlist(institutionid, 1027, 206257)
replace parent_name = "USCA ASSET MANAGEMENT" if inlist(institutionid, 6000326)
replace parent_name = "USCF ADVISERS" if inlist(institutionid, 6000349)
replace parent_name = "UTC NORTH AMERICAN FUND" if inlist(institutionid, 6000039)
replace parent_name = "VALIC" if inlist(institutionid, 206191)
replace parent_name = "VALUE LINE SECURITIES" if inlist(institutionid, 206258)
replace parent_name = "VAN DEN BERG MANAGEMENT" if inlist(institutionid, 206186, 6000231)
replace parent_name = "VAN ECK" if inlist(institutionid, 206187)
replace parent_name = "VAN KAMPEN" if inlist(institutionid, 5015033)
replace parent_name = "VANGUARD" if inlist(institutionid, 72998)
replace parent_name = "VERICIMETRY ADVISORS" if inlist(institutionid, 6000232)
replace parent_name = "VICTORIA 1522 INVESTMENTS" if inlist(institutionid, 6000025)
replace parent_name = "VIKING FUND MANAGEMENT" if inlist(institutionid, 206192)
replace parent_name = "VIRTUS" if inlist(institutionid, 6000073)
replace parent_name = "VOLUMETRIC ADVISERS" if inlist(institutionid, 206194)
replace parent_name = "VTL ASSOCIATES" if inlist(institutionid, 6000012)
replace parent_name = "W H REAVES & COMPANY" if inlist(institutionid, 206195)
replace parent_name = "WACHOVIA BANK OF NC" if inlist(institutionid, 5025732)
replace parent_name = "WADDELL & REED IVY" if inlist(institutionid, 1061, 75131, 6000122)
replace parent_name = "WAKEFIELD ADVISORS" if inlist(institutionid, 6000293)
replace parent_name = "WALL STREET MANAGEMENT CORPORATION" if inlist(institutionid, 206196)
replace parent_name = "WALTHAUSEN & CO" if inlist(institutionid, 6000233)
replace parent_name = "WASATCH ADVISORS" if inlist(institutionid, 206198)
replace parent_name = "WATER ISLAND CAPITAL" if inlist(institutionid, 1133)
replace parent_name = "WCM INVESTMENT MANAGEMENT" if inlist(institutionid, 6000142)
replace parent_name = "WELLS FARGO" if inlist(institutionid, 74908, 206201)
replace parent_name = "WESBANCO BANK WHEELING" if inlist(institutionid, 206203)
replace parent_name = "WEST SHORE GROUP" if inlist(institutionid, 6000364)
replace parent_name = "WESTCHESTER CAPITAL MANAGEMENT" if inlist(institutionid, 1208)
replace parent_name = "WESTPORT ADVISERS" if inlist(institutionid, 1135)
replace parent_name = "WESTWOOD MANAGEMENT CORP" if inlist(institutionid, 6000048)
replace parent_name = "WHITEBOX ADVISORS" if inlist(institutionid, 6000294)
replace parent_name = "WILLIAM BLAIR & COMPANY" if inlist(institutionid, 11447)
replace parent_name = "WILLIS GROUP" if inlist(institutionid, 206326)
replace parent_name = "WILMINGTON" if inlist(institutionid, 1014)
replace parent_name = "WILSHIRE" if inlist(institutionid, 206205)
replace parent_name = "WINNING POINTS ADVISORS" if inlist(institutionid, 6000112)
replace parent_name = "WINTERGREEN ADVISERS" if inlist(institutionid, 1136)
replace parent_name = "WINTON CAPITAL US" if inlist(institutionid, 6000327)
replace parent_name = "WISCONSIN CAPITAL MANAGEMENT" if inlist(institutionid, 206330)
replace parent_name = "WISDOMTREE" if inlist(institutionid, 206206)
replace parent_name = "WM GROUP OF FUNDS" if inlist(institutionid, 1028)
replace parent_name = "WRIGHT INVESTORS SERVICE" if inlist(institutionid, 206207)
replace parent_name = "XSHARES ADVISORS" if inlist(institutionid, 1209)
replace parent_name = "YACKTMAN ASSET MANAGEMENT COMPANY" if inlist(institutionid, 1138)
replace parent_name = "YCG" if inlist(institutionid, 6000081)
replace parent_name = "YIELDQUEST ADVISORS" if inlist(institutionid, 1139)
replace parent_name = "YORKTOWN MANAGEMENT & RESEARCH COMPANY" if inlist(institutionid, 6000366)
replace parent_name = "ZIEGLER LOTSOFF" if inlist(institutionid, 206209)
replace parent_name = "ZWEIG/GLASER ADVISERS" if inlist(institutionid, 6000071)

replace parent_name = "EATON VANCE" if inlist(institutionid, 1003) & meetingdate >= mdy(12,30,2016) 
replace parent_name = "PNC" if inlist(institutionid, 1012) & meetingdate >= mdy(3,2,2007)
replace parent_name = "M&T" if inlist(institutionid, 1014) & meetingdate >= mdy(5,16,2011)
replace parent_name = "GUARDIAN INVESTOR SERVICES" if inlist(institutionid, 1022) & meetingdate >= mdy(5,17,2006)
replace parent_name = "VICTORY" if inlist(institutionid, 1022) & meetingdate >= mdy(7,9,2016)
replace parent_name = "GUGGENHEIM" if inlist(institutionid, 1043) & meetingdate >= mdy(8,2,2010)
replace parent_name = "GUGGENHEIM" if inlist(institutionid, 1094) & meetingdate >=mdy(10,14,2009)
replace parent_name = "TIAA-CREF" if inlist(institutionid, 1116) & meetingdate >= mdy(10,1,2014)
replace parent_name = "BNYM" if inlist(institutionid, 1129) & meetingdate >= mdy(7,2,2007)
replace parent_name = "VICTORY" if inlist(institutionid, 1148) & meetingdate >= mdy(10,31,2014)
replace parent_name = "IMPAX ASSET MANAGEMENT GROUP" if inlist(institutionid, 1151) & meetingdate >= mdy(1,19,2018)
replace parent_name = "TA ASSOCIATES" if inlist(institutionid, 1171) & meetingdate >= mdy(7,23,2008)
replace parent_name = "TETON ADVISORS" if inlist(institutionid, 1171) & meetingdate >= mdy(3,1,2017)
replace parent_name = "NVEST FUND MANAGEMENT" if inlist(institutionid, 1211) & meetingdate >=mdy(2,19,2008)
replace parent_name = "BNYM" if inlist(institutionid, 15081) & meetingdate >= mdy(7,2,2007)
replace parent_name = "CARLYLE GMS INVESTMENT MANAGEMENT" if inlist(institutionid, 27450) & meetingdate >= mdy(2,6,2013)
replace parent_name = "AMERIPRISE" if inlist(institutionid, 28501) & meetingdate >= mdy(5,3,2010)
replace parent_name = "PNC" if inlist(institutionid, 46137) & meetingdate >= mdy(12,1,2009)
replace parent_name = "NATIONAL CITY BANK" if inlist(institutionid, 53516) & meetingdate >= mdy(4,9,2004)
replace parent_name = "NOMURA" if inlist(institutionid, 70245) & meetingdate >= mdy(5,19,2016)
replace parent_name = "VICTORY" if inlist(institutionid, 76516) & meetingdate >= mdy(8,1,2013)
replace parent_name = "PNC" if inlist(institutionid, 89688) & meetingdate >= mdy(9,29,2006)
replace parent_name = "NUVEEN" if inlist(institutionid, 103059) & meetingdate >= mdy(12,31,2010)
replace parent_name = "ALLIANZ" if inlist(institutionid, 206126) & meetingdate >= mdy(10,17,2008)
replace parent_name = "RAYMOND JAMES" if inlist(institutionid, 206177) & meetingdate >= mdy(11,20,2017)
replace parent_name = "MACQUARIE" if inlist(institutionid, 206227) & meetingdate  >= mdy(1,4,2010)
replace parent_name = "ALLIANZ" if inlist(institutionid, 206252) & meetingdate >= mdy(4,1,2013)
replace parent_name = "SGI" if inlist(institutionid, 206253) & meetingdate >= mdy(1,18,2008)
replace parent_name = "GUGGENHEIM" if inlist(institutionid, 206253) & meetingdate >= mdy(8,2,2010) 
replace parent_name = "JOHN HANCOCK" if inlist(institutionid, 206334) & meetingdate >=mdy(2,11,2011)
replace parent_name = "BNYM" if inlist(institutionid, 5014056) & meetingdate >= mdy(7,31,2007)
replace parent_name = "INVESCO" if inlist(institutionid, 5015033) & meetingdate >= mdy(6,1,2010)
replace parent_name = "LEHMAN BROTHERS" if inlist(institutionid, 5102137) & meetingdate >= mdy(10,31,2003) 
replace parent_name = "NEUBERGER BERMAN" if inlist(institutionid, 5102137) & meetingdate >= mdy(10,31,2011) 
replace parent_name = "MASSMUTUAL" if inlist(institutionid, 6000012) & meetingdate >= mdy(9,9,2015)
replace parent_name = "GUGGENHEIM" if inlist(institutionid, 6000016) & meetingdate >= mdy(8,2,2010)
replace parent_name = "RBC" if inlist(institutionid, 6000019) & meetingdate >= mdy(11,2,2015)
replace parent_name = "JP MORGAN CHASE" if inlist(institutionid, 6000027) & meetingdate >= mdy(4,4,2016)
replace parent_name = "RBC" if inlist(institutionid, 6000047) & meetingdate >= mdy(11,2,2015)
replace parent_name = "COLUMBIA" if inlist(institutionid, 6000166) & meetingdate >= mdy(9,1,2016)
replace parent_name = "SALIENT" if inlist(institutionid, 6000196) & meetingdate >= mdy(6,10,2015)
replace parent_name = "LEGG MASON" if inlist(institutionid, 6000285) & meetingdate >= mdy(1,22,2016)
replace parent_name = "AMERICAN BEACON ADVISORS" if inlist(institutionid, 6000353) & meetingdate >= mdy(7,14,2016)
replace parent_name = "VICTORY" if inlist(institutionid, 6000355) & meetingdate >= mdy(5,1,2015)
drop if missing(parent_name)

